/*
 Navicat Premium Data Transfer

 Source Server         : demo
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : day17-monthtestA

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 29/12/2022 20:13:33
*/


-- ----------------------------
-- Table structure for student_city
-- ----------------------------
DROP TABLE IF EXISTS `student_city`;
CREATE TABLE `student_city` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of student_city
-- ----------------------------
BEGIN;
INSERT INTO `student_city` (`id`, `name`) VALUES (1, '纽约');
INSERT INTO `student_city` (`id`, `name`) VALUES (2, '华盛顿');
INSERT INTO `student_city` (`id`, `name`) VALUES (3, '洛杉矶');
INSERT INTO `student_city` (`id`, `name`) VALUES (4, '西雅图');
INSERT INTO `student_city` (`id`, `name`) VALUES (5, '迈阿密');
COMMIT;

